package com.smile.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.smile.model.domain.CountFlight;
import com.smile.model.domain.FeisuanFlightTask;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface FlightTaskMapper extends BaseMapper<FeisuanFlightTask> {

//    @Select("select sum(flight_time) as time,sum(flight_distance) as distance,count(id) as num from feisuan_flight_task")
    @Select("select sum(total_task_time) as time,sum(total_task_distance) as distance,sum(task_count) as num from feisuan_flight_statistics")
    CountFlight countFlight();
}
